package cn.exrick.xboot.index.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface IndexMapper {
    /**
     * 统计当天登录人数
     * @return
     */
    int countHontLog();
    int countInstanceinfo();
    int countInstanceinfoByMouth();
    int sumInstanceinfoTime();
    int countTimeOut();
//    List<Map<String, Object>> totalHontLogDay(String beginDate,String endDate);
    List<Map<String, Object>> totalHontLog(String dateType,String beginDate,String endDate);
    List<Map<String, Object>> totalHontLogOnDePart(String beginDate, String endDate);

    List<Map<String, Object>> totalInstanceinfoCount(String dateType,String beginDate,String endDate);
    List<Map<String, Object>> totalInstanceinfoOnDePart(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomAvg(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomTimeOrder(String beginDate, String endDate);
    List<Map<String, Object>> countIndexBottomTime(String beginDate, String endDate,Integer firstRow,Integer lastRow);

}
